﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TSqlServer;

public partial class ajax_findman : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string manname = Request["manname"].ToString();

        int iflag = 0;
        string result = "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\">";
        string sSql = "select linkman,company,bigname from vw_linkman where bigname<>'汽车画报' and linkman='" + manname + "'";
        TSqlDBReader oMans = new TSqlDBReader(sSql);
        while (oMans.FDataReader.Read())
        {
            result += "<tr>";
            result += "<td>&nbsp;·" + oMans.FDataReader.GetValue(0).ToString() + "(" + oMans.FDataReader.GetValue(1).ToString() + ")</td>";
            result += "<td>&nbsp;>>>&nbsp;&nbsp;" + oMans.FDataReader.GetValue(2).ToString() + "</td>";
            result += "</tr>";
            iflag++;
        }
        oMans.Free();

        result += "</table>";

        if (iflag > 0)
        {
            linkmans.InnerHtml = result;
        }
        else
        {
            linkmans.InnerHtml = "&nbsp;没有找到人！";
        }
    }
}
